package com.ship.dispatch.mapper.fob;/*
 *@title SpFobGmbxMapper
 *@description
 *@author yl
 *@create 2023/12/16 0016
 */

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ship.dispatch.bean.fob.SpFobGmbx;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Map;

public interface SpFobGmbxMapper extends BaseMapper<SpFobGmbx> {

    @Select("select id,contract_name as contractName  from con_insurance_goods where  status<=3 and expiration_date > NOW() LIMIT 1")
    Map<String, Object> selectConInsuranceGoods(@Param("tradeBody") Integer tradeBody);
}
